Pandas Profiling Report

Dataset statistics

Number of variables	12
Number of observations	2966
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	301.2 KiB
Average record size in memory	104.0 B

Variable types

Numeric	12

Alerts

`gross_revenue` is highly overall correlated with `qtd_invoices` and 3 other fields	High correlation
`recency` is highly overall correlated with `qtd_invoices`	High correlation
`qtd_invoices` is highly overall correlated with `gross_revenue` and 3 other fields	High correlation
`qtd_items` is highly overall correlated with `gross_revenue` and 3 other fields	High correlation
`qtd_products` is highly overall correlated with `gross_revenue` and 3 other fields	High correlation
`avg_ticket` is highly overall correlated with `avg_unique_basket_size`	High correlation
`avg_recency_days` is highly overall correlated with `frequency`	High correlation
`frequency` is highly overall correlated with `avg_recency_days`	High correlation
`avg_basket_size` is highly overall correlated with `gross_revenue` and 1 other fields	High correlation
`avg_unique_basket_size` is highly overall correlated with `qtd_products` and 1 other fields	High correlation
`avg_ticket` is highly skewed (γ1 = 53.41723734)	Skewed
`returns` is highly skewed (γ1 = 51.77229749)	Skewed
`avg_basket_size` is highly skewed (γ1 = 44.6542745)	Skewed
`customer_id` has unique values	Unique
`recency` has 34 (1.1%) zeros	Zeros
`returns` has 1480 (49.9%) zeros	Zeros

Reproduction

Analysis started	2023-11-07 20:06:45.363535
Analysis finished	2023-11-07 20:07:35.269969
Duration	49.91 seconds
Software version	ydata-profiling vv4.6.0
Download configuration	config.json

customer_id
Real number (ℝ)

UNIQUE

Distinct	2966
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15270.646

Minimum	12347
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.3 KiB

Quantile statistics

Minimum	12347
5-th percentile	12619.25
Q1	13799.75
median	15220.5
Q3	16769.5
95-th percentile	17964.75
Maximum	18287
Range	5940
Interquartile range (IQR)	2969.75

Descriptive statistics

Standard deviation	1719.3683
Coefficient of variation (CV)	0.11259302
Kurtosis	-1.2062852
Mean	15270.646
Median Absolute Deviation (MAD)	1487
Skewness	0.031911548
Sum	45292737
Variance	2956227.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17850	1	< 0.1%
17588	1	< 0.1%
14905	1	< 0.1%
16103	1	< 0.1%
14626	1	< 0.1%
14868	1	< 0.1%
18246	1	< 0.1%
17115	1	< 0.1%
16611	1	< 0.1%
15912	1	< 0.1%
Other values (2956)	2956	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12347	1	< 0.1%
12348	1	< 0.1%
12352	1	< 0.1%
12356	1	< 0.1%
12358	1	< 0.1%
12359	1	< 0.1%
12360	1	< 0.1%
12362	1	< 0.1%
12364	1	< 0.1%
12370	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18283	1	< 0.1%
18282	1	< 0.1%
18277	1	< 0.1%
18276	1	< 0.1%
18274	1	< 0.1%
18273	1	< 0.1%
18272	1	< 0.1%
18270	1	< 0.1%
18269	1	< 0.1%

gross_revenue
Real number (ℝ)

HIGH CORRELATION

Distinct	2951
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2751.6337

Minimum	6.2
Maximum	279138.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.3 KiB

Quantile statistics

Minimum	6.2
5-th percentile	230.9525
Q1	571.02
median	1088.53
Q3	2310.295
95-th percentile	7226.025
Maximum	279138.02
Range	279131.82
Interquartile range (IQR)	1739.275

Descriptive statistics

Standard deviation	10585.697
Coefficient of variation (CV)	3.847059
Kurtosis	353.6074
Mean	2751.6337
Median Absolute Deviation (MAD)	673.06
Skewness	16.769761
Sum	8161345.4
Variance	1.1205698 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2053.02	2	0.1%
331	2	0.1%
734.94	2	0.1%
1025.44	2	0.1%
598.2	2	0.1%
533.33	2	0.1%
731.9	2	0.1%
2092.32	2	0.1%
379.65	2	0.1%
745.06	2	0.1%
Other values (2941)	2946	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6.2	1	< 0.1%
13.3	1	< 0.1%
36.56	1	< 0.1%
45	1	< 0.1%
52	1	< 0.1%
52.2	1	< 0.1%
52.2	1	< 0.1%
62.43	1	< 0.1%
68.84	1	< 0.1%
70.02	1	< 0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
168472.5	1	< 0.1%
140450.72	1	< 0.1%
124564.53	1	< 0.1%
117379.63	1	< 0.1%
91062.38	1	< 0.1%
72882.09	1	< 0.1%
66653.56	1	< 0.1%

recency
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	272
Distinct (%)	9.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	64.192852

Minimum	0
Maximum	373
Zeros	34
Zeros (%)	1.1%
Negative	0
Negative (%)	0.0%
Memory size	46.3 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	11
median	31
Q3	81
95-th percentile	242
Maximum	373
Range	373
Interquartile range (IQR)	70

Descriptive statistics

Standard deviation	77.574664
Coefficient of variation (CV)	1.2084627
Kurtosis	2.7616799
Mean	64.192852
Median Absolute Deviation (MAD)	26
Skewness	1.7950064
Sum	190396
Variance	6017.8286
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	99	3.3%
4	87	2.9%
3	85	2.9%
2	84	2.8%
8	76	2.6%
10	67	2.3%
7	66	2.2%
9	66	2.2%
17	64	2.2%
16	55	1.9%
Other values (262)	2217	74.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	34	1.1%
1	99	3.3%
2	84	2.8%
3	85	2.9%
4	87	2.9%
5	43	1.4%
7	66	2.2%
8	76	2.6%
9	66	2.2%
10	67	2.3%

Value	Count	Frequency (%)
373	2	0.1%
372	3	0.1%
371	1	< 0.1%
368	1	< 0.1%
366	4	0.1%
365	2	0.1%
364	1	< 0.1%
360	1	< 0.1%
359	1	< 0.1%
358	4	0.1%

qtd_invoices
Real number (ℝ)

HIGH CORRELATION

Distinct	56
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.7242077

Minimum	1
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.3 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	6
95-th percentile	17
Maximum	206
Range	205
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	8.8551469
Coefficient of variation (CV)	1.5469646
Kurtosis	191.00754
Mean	5.7242077
Median Absolute Deviation (MAD)	2
Skewness	10.770512
Sum	16978
Variance	78.413626
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	785	26.5%
3	497	16.8%
4	394	13.3%
5	236	8.0%
1	189	6.4%
6	173	5.8%
7	139	4.7%
8	98	3.3%
9	68	2.3%
10	55	1.9%
Other values (46)	332	11.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	189	6.4%
2	785	26.5%
3	497	16.8%
4	394	13.3%
5	236	8.0%
6	173	5.8%
7	139	4.7%
8	98	3.3%
9	68	2.3%
10	55	1.9%

Value	Count	Frequency (%)
206	1	< 0.1%
199	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	1	< 0.1%
90	1	< 0.1%
86	1	< 0.1%
72	1	< 0.1%
62	2	0.1%
60	1	< 0.1%

qtd_items
Real number (ℝ)

HIGH CORRELATION

Distinct	1672
Distinct (%)	56.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1610.2599

Minimum	2
Maximum	196844
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.3 KiB

Quantile statistics

Minimum	2
5-th percentile	103
Q1	297
median	642
Q3	1401
95-th percentile	4408
Maximum	196844
Range	196842
Interquartile range (IQR)	1104

Descriptive statistics

Standard deviation	5890.3815
Coefficient of variation (CV)	3.6580315
Kurtosis	465.56335
Mean	1610.2599
Median Absolute Deviation (MAD)	422.5
Skewness	17.850458
Sum	4776031
Variance	34696595
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
310	11	0.4%
88	9	0.3%
150	9	0.3%
288	8	0.3%
246	8	0.3%
272	8	0.3%
260	8	0.3%
84	8	0.3%
114	7	0.2%
493	7	0.2%
Other values (1662)	2883	97.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	2	0.1%
12	2	0.1%
16	1	< 0.1%
17	1	< 0.1%
18	1	< 0.1%
19	1	< 0.1%
20	1	< 0.1%
23	1	< 0.1%
25	1	< 0.1%
26	1	< 0.1%

Value	Count	Frequency (%)
196844	1	< 0.1%
80997	1	< 0.1%
80263	1	< 0.1%
77373	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%
64124	1	< 0.1%
63312	1	< 0.1%
58343	1	< 0.1%
57885	1	< 0.1%

qtd_products
Real number (ℝ)

HIGH CORRELATION

Distinct	467
Distinct (%)	15.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	122.81187

Minimum	1
Maximum	7838
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.3 KiB

Quantile statistics

Minimum	1
5-th percentile	9
Q1	29
median	67
Q3	135
95-th percentile	382
Maximum	7838
Range	7837
Interquartile range (IQR)	106

Descriptive statistics

Standard deviation	270.00815
Coefficient of variation (CV)	2.1985509
Kurtosis	354.60552
Mean	122.81187
Median Absolute Deviation (MAD)	44
Skewness	15.702618
Sum	364260
Variance	72904.399
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28	43	1.4%
20	37	1.2%
29	35	1.2%
35	35	1.2%
19	34	1.1%
15	33	1.1%
11	32	1.1%
25	31	1.0%
27	30	1.0%
26	30	1.0%
Other values (457)	2626	88.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	5	0.2%
2	14	0.5%
3	16	0.5%
4	17	0.6%
5	26	0.9%
6	28	0.9%
7	18	0.6%
8	19	0.6%
9	26	0.9%
10	28	0.9%

Value	Count	Frequency (%)
7838	1	< 0.1%
5673	1	< 0.1%
5095	1	< 0.1%
4580	1	< 0.1%
2697	1	< 0.1%
2379	1	< 0.1%
2060	1	< 0.1%
1818	1	< 0.1%
1672	1	< 0.1%
1637	1	< 0.1%

avg_ticket
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	2964
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	51.936044

Minimum	2.1505882
Maximum	56157.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.3 KiB

Quantile statistics

Minimum	2.1505882
5-th percentile	4.9143418
Q1	13.119823
median	17.977335
Q3	24.991714
95-th percentile	90.50125
Maximum	56157.5
Range	56155.349
Interquartile range (IQR)	11.871892

Descriptive statistics

Standard deviation	1037.4582
Coefficient of variation (CV)	19.975687
Kurtosis	2887.7878
Mean	51.936044
Median Absolute Deviation (MAD)	5.9963256
Skewness	53.417237
Sum	154042.31
Variance	1076319.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14.47833333	2	0.1%
4.162	2	0.1%
18.15222222	1	< 0.1%
12.949	1	< 0.1%
16.29372093	1	< 0.1%
36.24411765	1	< 0.1%
29.78416667	1	< 0.1%
22.8792623	1	< 0.1%
20.51104167	1	< 0.1%
149.025	1	< 0.1%
Other values (2954)	2954	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.150588235	1	< 0.1%
2.4325	1	< 0.1%
2.462371134	1	< 0.1%
2.511241379	1	< 0.1%
2.515333333	1	< 0.1%
2.65	1	< 0.1%
2.656931818	1	< 0.1%
2.707598253	1	< 0.1%
2.760621572	1	< 0.1%
2.770464191	1	< 0.1%

Value	Count	Frequency (%)
56157.5	1	< 0.1%
4453.43	1	< 0.1%
3202.92	1	< 0.1%
1687.2	1	< 0.1%
952.9875	1	< 0.1%
872.13	1	< 0.1%
841.0214493	1	< 0.1%
651.1683333	1	< 0.1%
640	1	< 0.1%
624.4	1	< 0.1%

avg_recency_days
Real number (ℝ)

HIGH CORRELATION

Distinct	1258
Distinct (%)	42.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	67.378936

Minimum	1
Maximum	366
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.3 KiB

Quantile statistics

Minimum	1
5-th percentile	8
Q1	26
median	48.392857
Q3	85.333333
95-th percentile	201
Maximum	366
Range	365
Interquartile range (IQR)	59.333333

Descriptive statistics

Standard deviation	63.561155
Coefficient of variation (CV)	0.94333867
Kurtosis	4.8826514
Mean	67.378936
Median Absolute Deviation (MAD)	26.27381
Skewness	2.06229
Sum	199845.92
Variance	4040.0205
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14	25	0.8%
70	21	0.7%
4	21	0.7%
7	20	0.7%
35	18	0.6%
49	18	0.6%
46	17	0.6%
21	17	0.6%
11	17	0.6%
28	16	0.5%
Other values (1248)	2776	93.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	16	0.5%
1.5	1	< 0.1%
2	13	0.4%
2.5	1	< 0.1%
2.601398601	1	< 0.1%
3	15	0.5%
3.321428571	1	< 0.1%
3.330357143	1	< 0.1%
3.5	2	0.1%
4	21	0.7%

Value	Count	Frequency (%)
366	1	< 0.1%
365	1	< 0.1%
363	1	< 0.1%
362	1	< 0.1%
357	2	0.1%
356	1	< 0.1%
355	2	0.1%
352	1	< 0.1%
351	2	0.1%
350	3	0.1%

frequency
Real number (ℝ)

HIGH CORRELATION

Distinct	1349
Distinct (%)	45.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.06316847

Minimum	0.0054495913
Maximum	3
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.3 KiB

Quantile statistics

Minimum	0.0054495913
5-th percentile	0.0094339623
Q1	0.017777778
median	0.029296366
Q3	0.055319294
95-th percentile	0.22222222
Maximum	3
Range	2.9945504
Interquartile range (IQR)	0.037541516

Descriptive statistics

Standard deviation	0.13440508
Coefficient of variation (CV)	2.1277241
Kurtosis	121.98493
Mean	0.06316847
Median Absolute Deviation (MAD)	0.014270062
Skewness	8.7943007
Sum	187.35768
Variance	0.018064725
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.3333333333	21	0.7%
0.1666666667	21	0.7%
0.02777777778	20	0.7%
0.09090909091	19	0.6%
0.0625	17	0.6%
0.1333333333	16	0.5%
0.25	15	0.5%
0.02380952381	15	0.5%
0.4	15	0.5%
0.03571428571	15	0.5%
Other values (1339)	2792	94.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.005449591281	1	< 0.1%
0.005464480874	1	< 0.1%
0.005494505495	1	< 0.1%
0.005509641873	1	< 0.1%
0.005586592179	2	0.1%
0.005602240896	1	< 0.1%
0.005617977528	2	0.1%
0.00566572238	1	< 0.1%
0.005681818182	2	0.1%
0.005698005698	3	0.1%

Value	Count	Frequency (%)
3	1	< 0.1%
2	1	< 0.1%
1.571428571	1	< 0.1%
1.5	3	0.1%
1	14	0.5%
0.8333333333	1	< 0.1%
0.75	1	< 0.1%
0.6666666667	12	0.4%
0.6514745308	1	< 0.1%
0.6	1	< 0.1%

returns
Real number (ℝ)

SKEWED ZEROS

Distinct	214
Distinct (%)	7.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	62.124073

Minimum	0
Maximum	80995
Zeros	1480
Zeros (%)	49.9%
Negative	0
Negative (%)	0.0%
Memory size	46.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	9
95-th percentile	100
Maximum	80995
Range	80995
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	1513.2549
Coefficient of variation (CV)	24.358591
Kurtosis	2762.7859
Mean	62.124073
Median Absolute Deviation (MAD)	1
Skewness	51.772297
Sum	184260
Variance	2289940.4
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1480	49.9%
1	164	5.5%
2	147	5.0%
3	105	3.5%
4	89	3.0%
6	78	2.6%
5	61	2.1%
12	51	1.7%
7	43	1.4%
8	43	1.4%
Other values (204)	705	23.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1480	49.9%
1	164	5.5%
2	147	5.0%
3	105	3.5%
4	89	3.0%
5	61	2.1%
6	78	2.6%
7	43	1.4%
8	43	1.4%
9	41	1.4%

Value	Count	Frequency (%)
80995	1	< 0.1%
9014	1	< 0.1%
8004	1	< 0.1%
4427	1	< 0.1%
3768	1	< 0.1%
3332	1	< 0.1%
2878	1	< 0.1%
2022	1	< 0.1%
2012	1	< 0.1%
1776	1	< 0.1%

avg_basket_size
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	1979
Distinct (%)	66.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	250.04185

Minimum	1
Maximum	40498.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.3 KiB

Quantile statistics

Minimum	1
5-th percentile	44.291667
Q1	103.30833
median	172.38095
Q3	281.92308
95-th percentile	600
Maximum	40498.5
Range	40497.5
Interquartile range (IQR)	178.61474

Descriptive statistics

Standard deviation	791.92626
Coefficient of variation (CV)	3.1671748
Kurtosis	2253.5421
Mean	250.04185
Median Absolute Deviation (MAD)	83.083333
Skewness	44.654274
Sum	741624.13
Variance	627147.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	11	0.4%
114	10	0.3%
73	9	0.3%
82	9	0.3%
86	9	0.3%
136	8	0.3%
60	8	0.3%
88	8	0.3%
75	8	0.3%
197	7	0.2%
Other values (1969)	2879	97.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3.333333333	1	< 0.1%
5.333333333	1	< 0.1%
5.666666667	1	< 0.1%
6.142857143	1	< 0.1%
7.5	1	< 0.1%
9	1	< 0.1%
9.5	1	< 0.1%
11	1	< 0.1%

Value	Count	Frequency (%)
40498.5	1	< 0.1%
6009.333333	1	< 0.1%
4282	1	< 0.1%
3906	1	< 0.1%
3868.65	1	< 0.1%
2880	1	< 0.1%
2801	1	< 0.1%
2733.944444	1	< 0.1%
2518.769231	1	< 0.1%
2160.333333	1	< 0.1%

avg_unique_basket_size
Real number (ℝ)

HIGH CORRELATION

Distinct	1006
Distinct (%)	33.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22.174744

Minimum	1
Maximum	299.70588
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.3 KiB

Quantile statistics

Minimum	1
5-th percentile	3.4802632
Q1	10.020833
median	17.2
Q3	27.75
95-th percentile	57
Maximum	299.70588
Range	298.70588
Interquartile range (IQR)	17.729167

Descriptive statistics

Standard deviation	19.523034
Coefficient of variation (CV)	0.88041754
Kurtosis	27.655868
Mean	22.174744
Median Absolute Deviation (MAD)	8.2
Skewness	3.4969867
Sum	65770.292
Variance	381.14885
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13	53	1.8%
14	39	1.3%
11	38	1.3%
20	33	1.1%
9	33	1.1%
1	31	1.0%
17	31	1.0%
18	30	1.0%
10	30	1.0%
16	29	1.0%
Other values (996)	2619	88.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	31	1.0%
1.2	1	< 0.1%
1.25	1	< 0.1%
1.333333333	2	0.1%
1.5	8	0.3%
1.568181818	1	< 0.1%
1.571428571	1	< 0.1%
1.666666667	4	0.1%
1.833333333	1	< 0.1%
2	24	0.8%

Value	Count	Frequency (%)
299.7058824	1	< 0.1%
259	1	< 0.1%
203.5	1	< 0.1%
148	1	< 0.1%
145	1	< 0.1%
136.125	1	< 0.1%
135.5	1	< 0.1%
127	1	< 0.1%
122	1	< 0.1%
118	1	< 0.1%

Auto

Heatmap
Table

	customer_id	gross_revenue	recency	qtd_invoices	qtd_items	qtd_products	avg_ticket	avg_recency_days	frequency	returns	avg_basket_size	avg_unique_basket_size
customer_id	1.000	-0.077	-0.000	0.026	-0.071	0.012	-0.130	0.018	-0.008	-0.064	-0.124	-0.008
gross_revenue	-0.077	1.000	-0.415	0.770	0.925	0.743	0.246	-0.249	0.162	0.373	0.574	0.289
recency	-0.000	-0.415	1.000	-0.502	-0.407	-0.435	0.048	0.108	-0.032	-0.121	-0.097	-0.106
qtd_invoices	0.026	0.770	-0.502	1.000	0.716	0.690	0.059	-0.260	0.150	0.295	0.099	0.024
qtd_items	-0.071	0.925	-0.407	0.716	1.000	0.729	0.167	-0.229	0.147	0.345	0.729	0.319
qtd_products	0.012	0.743	-0.435	0.690	0.729	1.000	-0.378	-0.167	0.102	0.243	0.382	0.699
avg_ticket	-0.130	0.246	0.048	0.059	0.167	-0.378	1.000	-0.122	0.099	0.190	0.187	-0.612
avg_recency_days	0.018	-0.249	0.108	-0.260	-0.229	-0.167	-0.122	1.000	-0.962	-0.397	-0.079	0.047
frequency	-0.008	0.162	-0.032	0.150	0.147	0.102	0.099	-0.962	1.000	0.360	0.058	-0.041
returns	-0.064	0.373	-0.121	0.295	0.345	0.243	0.190	-0.397	0.360	1.000	0.210	0.019
avg_basket_size	-0.124	0.574	-0.097	0.099	0.729	0.382	0.187	-0.079	0.058	0.210	1.000	0.446
avg_unique_basket_size	-0.008	0.289	-0.106	0.024	0.319	0.699	-0.612	0.047	-0.041	0.019	0.446	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	customer_id	gross_revenue	recency	qtd_invoices	qtd_items	qtd_products	avg_ticket	avg_recency_days	frequency	returns	avg_basket_size	avg_unique_basket_size
0	17850	5391.21	372.0	34.0	1733.0	297.0	18.152222	35.500000	0.486111	40.0	50.970588	8.735294
1	13047	3232.59	56.0	9.0	1390.0	171.0	18.904035	27.250000	0.048780	35.0	154.444444	19.000000
2	12583	6705.38	2.0	15.0	5028.0	232.0	28.902500	23.187500	0.045699	50.0	335.200000	15.466667
3	13748	948.25	95.0	5.0	439.0	28.0	33.866071	92.666667	0.017921	0.0	87.800000	5.600000
4	15100	876.00	333.0	3.0	80.0	3.0	292.000000	8.600000	0.136364	22.0	26.666667	1.000000
5	15291	4623.30	25.0	14.0	2102.0	102.0	45.326471	23.200000	0.054441	29.0	150.142857	7.285714
6	14688	5630.87	7.0	21.0	3621.0	327.0	17.219786	18.300000	0.073569	399.0	172.428571	15.571429
7	17809	5411.91	16.0	12.0	2057.0	61.0	88.719836	35.700000	0.039106	41.0	171.416667	5.083333
8	15311	60767.90	0.0	91.0	38194.0	2379.0	25.543464	4.144444	0.315508	474.0	419.714286	26.142857
9	16098	2005.63	87.0	7.0	613.0	67.0	29.934776	47.666667	0.024390	0.0	87.571429	9.571429

	customer_id	gross_revenue	recency	qtd_invoices	qtd_items	qtd_products	avg_ticket	avg_recency_days	frequency	returns	avg_basket_size	avg_unique_basket_size
5602	17727	1060.25	15.0	1.0	645.0	66.0	16.064394	6.0	0.285714	6.0	645.000000	66.0
5612	17232	421.52	2.0	2.0	203.0	36.0	11.708889	12.0	0.153846	0.0	101.500000	18.0
5613	17468	137.00	10.0	2.0	116.0	5.0	27.400000	4.0	0.400000	0.0	58.000000	2.5
5624	13596	697.04	5.0	2.0	406.0	166.0	4.199036	7.0	0.250000	0.0	203.000000	83.0
5630	14893	1237.85	9.0	2.0	799.0	73.0	16.956849	2.0	0.666667	0.0	399.500000	36.5
5634	12479	473.20	11.0	1.0	382.0	30.0	15.773333	4.0	0.333333	34.0	382.000000	30.0
5655	14126	706.13	7.0	3.0	508.0	15.0	47.075333	3.0	1.000000	50.0	169.333333	5.0
5661	13521	1092.39	1.0	3.0	733.0	435.0	2.511241	4.5	0.300000	0.0	244.333333	145.0
5671	15060	301.84	8.0	4.0	262.0	120.0	2.515333	1.0	2.000000	0.0	65.500000	30.0
5690	12558	269.96	7.0	1.0	196.0	11.0	24.541818	6.0	0.285714	196.0	196.000000	11.0

Overview

Variables

Interactions

Correlations

Missing values

Sample